Release 10.1A: OpenEdge Getting Started:
Database Essentials

Sports 2000 database

The Sports 2000 database is one of several sample databases provided with the product, and it is frequently used in the documentation to illustrate database concepts and programming techniques. This database holds the information necessary to track customers, take and process orders, bill customers, and track inventory. Table 1–1 describes the tables of the Sports 2000 database. For details about the fields and indexes of the Sports 2000 database, you can use the Data Dictionary or Data Admin Tool to create table and index reports. For details on how to create reports, see the online Help.

Table 1–1: The Sports 2000 database

Table	Description
Benefits	Contains employee benefits.
BillTo	Contains bill to address information for an order.
Bin	Represents the bins in each warehouse that contain items.
Customer	Contains customer information including balance and address.
Department	Contains a master listing of departments.
Employee	Stores employee information including name and address.
Family	Tracks an employee’s family information.
Feedback	Contains customer feedback regarding likes and dislikes.
InventoryTrans	Contains information about the movement of inventory.
Invoice	Contains financial information by invoice for the receivables subsystem.
Item	Provides quick reference for stocking, pricing, and descriptive information about items in inventory.
Local-Default	Contains format and label information for various countries.
Order	Contains sales and shipping header information for orders.
Order-Line	Provides identification of and pricing information for a specific item ordered on a specific order.
POLine	Contains the PO detail information including the item and quantity on the PO.
PurchaseOrder	Contains information pertaining to the purchase order including PO number and status.
Ref-Call	Contains all history for a customer.
Salesrep	Contains names, regions, and quotas for the sales people.
ShipTo	Contains the ship to address information for an order.
State	Provides U.S. state names, their abbreviations, and sales region.
Supplier	Contains a supplier’s name, address, and additional information pertaining to the supplier.
SupplierItemXr	Lists all of the items that are supplied by a particular supplier.
TimeSheet	Records time in and out, hours worked, and overtime.
Vacation	Tracks employee vacation time.
Warehouse	Contains warehouse information including warehouse name and address.